﻿CREATE PROCEDURE [dbo].[Hogar_PersonaReferencia_ObtenerTodas]
 @IntegranteId INT  
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   obtener todas las personas de referencia de un integrante 
-- Returns:    Area
/*****************************************************************************************************************************************/ 
	
	SELECT  [PersonaReferenciaId],
			[IntegranteId],
			[Nombre],
			[Apellido],
			[Telefono],
			ISNULL([Edad],0) AS [Edad],
			[TipoPersonaReferenciaId],
			[VinculoId]
	FROM	[dbo].[PersonaReferencia] WITH (NOLOCK)
	WHERE [IntegranteId] = @IntegranteId
	ORDER BY [Apellido], [Nombre]
	
END